package com.ssy.lingxi.purchase.entity.purchaseinquiry;

import lombok.Data;

import javax.persistence.*;

/**
* 采购询价单地址区域表
* @author wrc
* @date 2021/1/19
*/
@Data
@Entity
@Table(schema = "public", name = "pu_purchase_inquiry_area",indexes = {
        @Index(name = "pu_purchase_inquiry_area_area_code_idx",columnList = "areaCode"),
        @Index(name = "pu_purchase_inquiry_area_province_code_idx",columnList = "provinceCode"),
        @Index(name = "pu_purchase_inquiry_area_city_code_idx",columnList = "cityCode")
})

public class PurchaseInquiryArea {

    @Id
    @GeneratedValue(strategy= GenerationType.SEQUENCE,generator="purchase_inquiry_area_seq")
    @SequenceGenerator(sequenceName="pu_purchase_inquiry_area_seq", name="purchase_inquiry_area_seq",allocationSize = 1)
    private Long id;

    /**
     *采购单ID
     */
    private Long  purchaseInquiryId;

    /**
     * 省编码
     */
    private String provinceCode;

    /**
     * 省份
     */
    private String province;

    /**
     * 城市编码
     */
    private String cityCode;

    /**
     * 城市
     */
    private String city;

    /**
     * 区编码
     */
    private String areaCode;

    /**
     * 区
     */
    private String area;
}
